﻿/*Considered calling this [Execution] but I wanted to distinguish 
between a Catalog Execution and a thing that can be restarted*/
CREATE TABLE [RestartFramework].[ETLJob] 
(
	[ETLJobId]				SMALLINT			NOT NULL
,	[ETLJobName]			SYSNAME				NOT NULL
,	[ETLJobCreatedDate]		DATETIMEOFFSET(7)	NOT NULL DEFAULT SYSDATETIME()
,	CONSTRAINT [PK_RestartFrameworkETLJob] PRIMARY KEY ([ETLJobId]) 
,	CONSTRAINT [UK_RestartFrameworkETLJob_ETLJobName] UNIQUE ([ETLJobName])
)
